--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user`
(
    `id` int
(
    11
) NOT NULL,
    `username` varchar
(
    25
) NOT NULL,
    `email` varchar
(
    25
) NOT NULL,
    `password` varchar
(
    25
) NOT NULL,
    `role` varchar
(
    10
) NOT NULL,
    `avatar` varchar
(
    191
) DEFAULT NULL,
    `color` varchar
(
    191
) DEFAULT NULL,
    `date` varchar
(
    191
) DEFAULT NULL,
    `about` varchar
(
    191
) DEFAULT NULL
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `email`, `password`, `role`, `avatar`, `color`, `date`, `about`)
VALUES (1, 'Administrator', '', '12345', 'admin', '/upload/images/avatar/1.jpeg', '#f9fafb', '1997-01-10', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `user`
--
ALTER TABLE `user`
    ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
    MODIFY `id` int (11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
